home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
FishMarket 1.0
/
FishMarket v1.0.iso
/
fishies
/
126-150
/
disk_144
/
analyticalc
/
analykeypad.arc
/
PCCHELP.SEQ
< prev
next >
Wrap
Text File
|
1987-11-04
|
10KB
|
239 lines
A N A L Y T I C A L C H E L P S Y S T E M
To get HELP use the command Hn where n is 0 thru 8 for HELP 0
through HELP 8.
HELP 0 - This screen
HELP 1 - Summary of many PortaCalc commands (terse)
HELP 2 - Data Entry / Editing
HELP 3 - Calculation Control
HELP 4 - Cursor Motion and Positioning
HELP 5 - Cell Copy
HELP 6 - Add/Subtract Absolute Rows/Cols
HELP 7 - Add/Subtract Relocting, Rows or Cols.
HELP 8 - Change Display Size, Col Size, Load Data
HELP 9 - Keypad Diagram for IBM PC and compatibles
EN expression - Insert expression at current pos.
M1,M2,M3, or M4 - Motion up, down, left, right (auto)
DL var1:var2 Rn:m (or Cn:m) - Display Loc phys to row/col n-m
DF var1:var2 [format] - set display format. A or L shows text, else #
DT var1:var2 F or I - Set display number type to flt or int
DW n,m - set width of column n of display to m chars
DB c,r - Set display bounds at c cols, r rows (chars)
L var - Move cursor to var named (phys.) OA var or OR var=move displ. origin
V - redraw screen. VF - Disply. formulas. VM=no auto. redraw. K - interactive
calc. *E returns. ZA - zero all. ZE var1:var2 - zero var1 thru var2
X - exit program. W write screen to file or printer
CV v1:v2 v3:v4 copy value from v1:v2 to v3:v4 range; CR=copy and relocate vars.
CD v1:v2 v3:v4 copy display format. CF=copy formula. CA=copy all
P Put screen to file. G=get screen from file at curr.loc
1,2,3,4 - move cursor Up,Down,Left,Right. A[A/R]n[R/C] Add abs/reloc n Row/Col
Variable ranges are var1[:var2]. Var names P#+n#+m or
D#+n#+m are current Phys or Display locs + or - offsets
Expressions may use multiple stmts, use \ separators.
Use std FORTRAN function names + MIN, MAX, AVG, STD, AND, IOR, XOR, MOD,
or SUM. IF stmt format is IF [v1.REL.v2]yes-expr|else expr.
Rels are .LT.,.GT.,.EQ.,.NE.,.GE.,.LE.
R Recompute sheet. RM Recompute Manually only (R resets)
HELP 2 - Data Entry / Editing
E expression Enter expression into cell.
Formulas available (+ SQRT,SIN,COS,LOG,EXP,ATAN)
SUM[variables] Sum of all arguments
MAX[variables] Max of arguments
MIN[variables] Min of arguments
AVG[variables] Average of arguments
STD[variables] Standard deviation squared
IF [V1.rel.V2] statement | else-statement
In the first 5 cases, arguments are variable names separated by
commas, or variable ranges, or mixtures separaged by columns.
".REL." is any of the 6 forms:
.EQ. Equal .NE. Not Equal
.GT. Greater than .LT. Less than (V1 less than V2)
.GE. Greater or Equal .LE. Less than or Equal to (V1 =< V2)
*XV filename V1 Extract value at cell V1 in saved
sheet stored in filename.
ED `string1`string2` Replace string1 with string2
in current cell formula. Either
string may be null if desired.
HELP 3 - Calculation Control
R Recalculate all of the sheet.
RM Recalculate manually only until R command given
RF Recalculate sheet, force constant recalculation
K Drop into interactive calculator. *E returns to sheet
X Exit to operating system.
V Redraw screen with normal formats (View)
VF Redraw screen showing all formulas (View Formulas)
VM Dont redraw screen until a V or VF is given (View Manual)
VC,VB,VI View Color, Black&White, IBM BIOS - screen controls
ZA Zero whole sheet
ZE V1:V2 Zero variables in a row or column in range from
cell V1 to cell V2 (V1,V2 = names of cells)
@filespec Read filespec and execute commands as though
typed in.
PDF Put out current Display sheet (Formulas)
PPF Put out current Physical sheet (Formulas,
PDN Put out current Display sheet (Numbers)
PPN Put out current Physical sheet (Numbers)
W Write screen to hardcopy file.
HELP 4 - Cursor Motion and Positioning
L variable-name Position cursor at variable-name
M1, M2, M3, M4 Move Up, Down, Left, or Right after an Enter
(but not immediately)
1 or Uparrow (Move up)
2 or Downarrow (Move down)
3 or Left arrow (Move left)
4 or Right arrow (Move right)
OA variable Reset origin of display to variable
OR variable Reset display down and right to start with variable,
changing only region down and right of cursor
DL V1:V2 Rn:m point at display coordinates (n,m) (col,row)
and, going left to right along a Row, copy in
variables V1 through V2 (actually, point those
display sheet cells at variables V1 thru V2).
DL V1:V2 Cn:m point at display coordinates (n,m) (col,row)
and, going top to bottom along a Column, copy in
variables V1 through V2 (actually, point those
display sheet cells at variables V1 thru V2).
DF V1:V2 [format] Set display format of range V1:V2 to format
(format A means display formula.)
HELP 5 - Cell Copy
CA V1:V2 V3:V4 Copy all cell attributes from V1:V2
to V3:V4.
CV V1:V2 V3:V4 Copy numeric values only
CD V1:V2 V3:V4 Copy Display Formats only
CF V1:V2 V3:V4 Copy Formulas only (no relocation)
CR V1:V2 V3:V4 Copy all cell attributes as in CA but
relocate cell names to new location
from old one. Only relocate names right
of or below the cursor or on same row/col
with cursor (cells above or left of cursor
are NOT relocated). Label cells are not altered.
If V2 is missing, V1 is replicated to V3:V4 range.
HELP 6 - Add/Subtract Absolute Rows/Cols
AA number R Add "number" rows ahead of the current
physical position, moving all cells below
the current cell down by "number" rows and
losing the physical sheet`s bottom "number"
rows` contents, NOT adjusting variable references
where the variables are in the moved range
and are not the position independent (P## or D##
forms) type.
AA number C Add "number" columns ahead of the current
physical position, moving all cells right of
the current cell right by "number" columns and
losing the physical sheet`s bottom "number"
columns` contents, NOT adjusting variable references
where the variables are in the moved range
and are not the position independent (P## or D##
forms) type.
HELP 7 - Add/Subtract Relocting, Rows or Cols.
AR number R Add "number" rows ahead of the current
physical position, moving all cells below
the current cell down by "number" rows and
losing the physical sheet`s bottom "number"
rows` contents, adjusting variable references
where the variables are in the moved range
and are not the position independent (P## or D##
forms) type.
AR number C Add "number" columns ahead of the current
physical position, moving all cells right of
the current cell right by "number" columns and
losing the physical sheet`s bottom "number"
columns` contents, adjusting variable references
where the variables are in the moved range
and are not the position independent (P## or D##
forms) type.
HELP 8 - Change Display Size, Col Size, Load Data
DW N,M Set column N on display to be M characters wide
DB n,m Set number of columns displayed on screen
to n, number of rows displayed to m.
GD Reload sheet down/right onto display coords.
GP Reload sheet down/right onto physical coords.
< Rewind the current Portacalc input file
* any text Comment. (For command files.)
Hn Display a screen of help. n may be 0 to 9, default 0.
F filename/nnnn Read filename, skipping nnnn lines
if the "/nnnn" is there, and load
contents onto the currently displayed
screen, broken into columns as the
current screen is set up.
AnalytiCalc Keypad Standard Keys
-------------+------------
HELP key = HELP| GOLD | Search | _ is wildcard char
| F1 | F2 | Gold F2 = Incremental Insert
-------------+------------
(Alt F3=Cell |Copy Range | Save Sheet|
to Region) | F3 | F4 |
-------------+------------
ALT F5= Get |GET Sheet | Motion Dir| Gold F6 is copy ROW to area
Relocating | F5 | F6 | Gold Gold F6 is copy COL to area
-------------+------------
Gold F7 = Set |Set Window | Ins/Del | Insert or Delete Rows or Columns
Origin of dsp | F7 | F8 |
-------------+------------
Spawn new | New CLI | Recalc. | ALT F10 = Recalc with Force
CLI window | F9 | F10 |
-------------+------------
Cursor arrows move on screen.
X - Exit from spreadsheet.